Creating scripts manually

You can run data loads by entering the scripts manually.

Procedure

1. Create a scriptset.
2. Click the Scripts tab.
3. Click the Control Folder.
4. Click the Importers button.
5. Import the data file.
6. Click the Table Declaration button.
7. Enter the data, for example:

   BEGIN TABLE_DECLARATION
   
   format = FLAT
   
   scriptfile = PERSON.TXT
   
   datfile = PersonData.dat
   
   type = REFRESH
   
   width = 81
   
   date = 16012004
   
   END TABLE_DECLARATION

   When a table has been declared and the Control File saved, a sub-folder is created which holds the table definitions.
8. Select the Person.txt folder.
9. Click the Table Definition button.
10. Enter the data, for example:

    TABLE = [test].[person]
    
    BEGIN TABLE_DEFINITION
    
    FID , TEXT , 0 , 8
    
    Forename , TEXT , 8 , 20
    
    Surname , TEXT , 28 , 30
    
    GENDER , TEXT , 58 , 1
    
    END TABLE_DEFINITION

    This provides the information necessary to run a simple data load.
11. Check your data is valid by using the Data Validation utility button.
    This checks the length of the first record and compares the all subsequent rows, reporting any differences.
12. Perform any other required tasks from the Scripts tab, for example linking databases and creating remaps.
13. Perform any data engineering before or after the data load.preload and post load processes can also be applied to the data load.

• Editing Scripts
  • Using The iLoader Editing Tools
  • Using the Table Declaration Wizard
  • Table Declaration File Structure
  • Table Declaration Example
  • Using the Table Definition Wizard
  • Table Definition File Structure
  • Table Definition Example
  • Indexing Fields
  • Creating Scripts Manually